<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %><%--
  Created by IntelliJ IDEA.
  User: 44659
  Date: 2018/5/14
  Time: 17:27
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>

<%@include file="isLogin.jsp"%>

<!-- 添加页面样式-->

<style type="text/css">

    table{

        border:2px solid #000000;
        border-collapse: collapse;
    }

    td,th{

        border: 2px solid #000000;
        padding: 10px;
    }

</style>

<!--基本表-->

<h1>用户列表</h1>

<p><a href="addUser.jsp">新增用户</a></p>

<table>
    <thead>
    <tr>
        <th>用户名</th>
        <th>密码</th>
        <th>功能1</th>
        <th>功能2</th>
    </tr>
    </thead>


    <%
        //User类

        class User {

            int id;
            String username;
            String password;
        }

            boolean isLogin = false;


             if (isLogin == false) {

            }

            List<User> userList = new ArrayList<User>();

            //3+1

            Connection connection = null;
            Statement statement = null;
            ResultSet resultSet = null;

            //sql语句,打印列表

            String sql = "select * from t_users";

            connection = DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=UTC",
                    "root",
                    "123456");

            statement = connection.createStatement();
            resultSet = statement.executeQuery(sql);

            while (resultSet.next()){

                int id = resultSet.getInt(1);
                String username = resultSet.getString(2);
                String password = resultSet.getString(3);

            }

            connection.close();
            statement.close();
            resultSet.close();

            for (User user : userList){

                out.write("<tr><td>" + user.id + "</td><td>" + user.username + "</td><td>"
                        + user.password + "</td>" + "<td><a href='userDelete.jsp?id="
                        + user.id + "'>删除</a></td>" + "<td><a href='userUpdate.jsp?id="
                        + user.id + "&username=" + user.username + "&password="
                        + user.password + "'>更新</a></td>" + "</tr>");
            }



    %>
</table>

<!--静态-->
<%@ include file="footer.jsp"%>

<!--JSP前缀 动态-->
<jsp:include page="footer.jsp">
    <jsp:param name="year" value="2018"/>
</jsp:include>

<!--添加页脚，使用动态，静态的两种方式-->


</body>
</html>
